Amazon MSK target data types
The following table shows the default mapping from Qlik Replicate data types to Amazon MSK data types.
For information on source data type mappings, see the section for the source endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
When using the JSON message format, binary values are represented as hexadecimal digits.
When using the Avro message format, logical data types are used.
Qlik Replicate Data Types | JSON Data Types | Avro Data Types |
---|---|---|
DATE |
STRING |
DATE Annotates an Avro INT. |
TIME |
STRING |
TIME-MILLIS Annotates an Avro INT. |
TIMESTAMP |
STRING |
TIMESTAMP-MICROS Annotates an Avro LONG. |
STRING |
STRING |
STRING |
WSTRING |
STRING |
STRING |
CLOB |
STRING |
STRING |
NCLOB |
STRING |
STRING |
NUMERIC |
STRING |
DECIMAL (p,s) Annotates an Avro BYTES. |
BYTES |
BYTES |
BYTES |
BLOB |
BYTES |
BYTES |
REAL4 |
FLOAT |
FLOAT |
REAL8 |
DOUBLE |
DOUBLE |
INT1 |
INT |
INT |
INT2 |
INT |
INT |
INT4 |
INT |
INT |
UINT1 |
INT |
INT |
UINT2 |
INT |
INT |
UINT4 |
LONG |
LONG |
INT8 |
LONG |
LONG |
UINT8 |
STRING |
DECIMAL (20,0) Annotates an Avro BYTES. |
BOOLEAN |
BOOLEAN |
BOOLEAN |